package com.excell.template.example;

import com.excell.support.excellbasic.ColumnCell;
import com.excell.support.excellbasic.ExcellCellBasics;
import com.excell.support.excellbasic.ExcellSheetBasic;
import com.excell.support.excellbasic.RowCell;
import com.excell.template.GlobalTemplate;

/**
 * @User c.c
 * @Since 2023/4/24
 * @Time 15:44
 * @Description
 */

public class TestOther extends GlobalTemplate<String> {
  @Override
  public ExcellSheetBasic<String> setExcellTitle() {
    ExcellSheetBasic<String> workBook = super.initSheet("项目测试表");

    StringBuilder title = new StringBuilder("计划实施项目名称：计划实施项目名称：22 \n");
    title.append("JT-XM-GKJJ-HW-202304-0006 \n").append("包件名称：包件名称：2 \n").append("项目报名情况");

    ExcellCellBasics<String> excellCellBasics = ExcellCellBasics.getInstance();
    excellCellBasics.initTitle(title.toString(), RowCell.intiRow(1), ColumnCell.intiColumn(1, 8))
      .initTitle("查询时间：    年  月  日  时  分",RowCell.intiRow(2),ColumnCell.intiColumn(1, 8))
      .initTitle("序号",RowCell.intiRow(3),ColumnCell.intiColumn(1))
      .initTitle("投标单位",RowCell.intiRow(3),ColumnCell.intiColumn(2))
      .initTitle("联系人",RowCell.intiRow(3),ColumnCell.intiColumn(3))
      .initTitle("联系电话",RowCell.intiRow(3),ColumnCell.intiColumn(4))
      .initTitle("邮箱",RowCell.intiRow(3),ColumnCell.intiColumn(5))
      .initTitle("提交时间",RowCell.intiRow(3),ColumnCell.intiColumn(6))
      .initTitle("状态",RowCell.intiRow(3),ColumnCell.intiColumn(7))
      .initTitle("备注",RowCell.intiRow(3),ColumnCell.intiColumn(8));
    workBook.initWorkBook(workBook.getWorkbook(), excellCellBasics);
    return workBook;
  }

  @Override
  public void setExcellContent(ExcellSheetBasic<String> excellSheetBasic) {

  }
}
